Limitations for transformation rules
The following limitations apply to transformation rules:
- Transformations are not supported for columns with Right-to-Left languages.
- Transformations cannot be performed on columns that contain special characters (e.g. #, \, /, -) in their name.
- The only supported transformation for columns that are mapped to BLOB/CLOB data types (by Replicate) is to drop the column on the target.
-
Expressions must be written using SQLite syntax only.
-
Changing a global transformation value will not reload affected tables automatically. The target must be reloaded manually for the changes to take effect.
For information on reloading the target, see Using the Run button options.
Information note
The options displayed in this screen depend on the Transformation Type selected.